 /*  SAS Data Definition File */
 /*  Created by ddltox on May 22, 2009  (Fri 12:53 PM PDT) */
 /*  DDL source file: "ocas97/ocas97.ddl". */

/* DDL indicates that dataset record length (reclen) is 78 columns. */

TITLE "ORANGE COUNTY ANNUAL SURVEY 1997";
FILENAME INDATA "    ";    /* Put name of data file between quotes */
LIBNAME LIBRARY "    ";    /* Put directory of data library between quotes */

PROC  FORMAT LIB=LIBRARY;
  VALUE q1ffffff  1='SINGLE FAMILY' 2='ATTACHED' 3='APARTMENT' 4='MOBILE' 
                  5='OTHER' 9='REFUSE' ;
  VALUE q2ffffff  1='0-2 YRS' 2='3-5 YRS' 3='6-10 YRS' 4='11-20 YRS' 
                  5='21+ YRS' 9='REFUSE' ;
  VALUE q3ffffff  1='OWN' 2='RENT' 9='DK, REFUSE' ;
  VALUE q4ffffff  1='UNDER $500' 2='$501-$750' 3='$751-$1,000' 
                  4='$1,001-$1,500' 5='$1,501+' 9='NA, REFUSE' ;
  VALUE q5ffffff  1='NOTHING' 2='$1-$500' 3='$501-$750' 4='$751-$1,000' 
                  5='$1,001-$1,500' 6='$1,501-$2,000' 7='$2,001+' 
                  9='NA, REFUSE' ;
  VALUE q6ffffff  1='BETTER OFF' 2='WORSE OFF' 3='SAME' 9='DK, REFUSE' ;
  VALUE q7ffffff  1='BETTER OFF' 2='WORSE OFF' 3='SAME' 8='DK' 9='REFUSE' ;
  VALUE q8ffffff  1='GOOD TIMES' 2='BAD TIMES' 8='DK' 9='REFUSE' ;
  VALUE q9ffffff  1='GOOD TIMES' 2='DEPRESSION' 8='DK' 9='REFUSE' ;
  VALUE q10fffff  1='GOOD TIME' 2='BAD TIME' 8='NEITHER, DK' 9='REFUSE' ;
  VALUE q11fffff  1='EXCELLENT' 2='GOOD' 3='FAIR' 4='POOR' 8='DK' 9='REFUSE' ;
  VALUE q12fffff  1='EXCELLENT' 2='GOOD' 3='FAIR' 4='POOR' 8='DK' 9='REFUSE' ;
  VALUE q13fffff  1='VERY WELL' 2='SOMEWHAT WELL' 3='SOMEWHAT BADLY' 
                  4='VERY BADLY' 9='DK, REFUSE' ;
  VALUE q14fffff  1='GROWTH' 2='TRAFFIC' 3='HOUSING' 4='CRIME' 5='SCHOOLS' 
                  6='IMMIGRATION' 7='ECONOMY' 8='FINANCIAL CRISIS' 98='OTHER' 
                  99='DK, REFUSE' ;
  VALUE q15fffff  1='HEALTH CARE' 2='CHILD CARE' 3='RACE RELATIONS' 
                  4='HOMELESS' 5='DRUG ABUSE' 6='AIDS' 7='OTHER' 8='DK' 
                  9='REFUSE' ;
  VALUE q16fffff  1='BETTER PLACE' 2='WORSE PLACE' 3='NO CHANGE' 
                  9='DK, REFUSE' ;
  VALUE q17fffff  1='EXCELLENT' 2='GOOD' 3='FAIR' 4='POOR' 8='DK' 9='REFUSE' ;
  VALUE q18fffff  1='A LOT' 2='SOME' 3='VERY LITTLE' 4='NONE' 8='DK' 
                  9='REFUSE' ;
  VALUE q19fffff  1='WASTE A LOT' 2='WASTE SOME' 3='WASTE LITTLE' 
                  4='WASTE NONE' 8='DK' 9='REFUSE' ;
  VALUE q20fffff  1='APPROVE' 2='DISAPROVE' 8='DK' 9='REFUSE' ;
  VALUE q21fffff  1='FAVOR' 2='OPPOSE' 8='DK' 9='REFUSE' ;
  VALUE q22fffff  1='TRANSIT CENTER' 2='ARENA' 3='AIRPORT' 
                  4='EDUCATION CENTER' 5='COMMERCIAL DVLPMT' 6='PARK' 
                  7='OTHER' 8='DK' 9='REFUSE' ;
  VALUE q23fffff  1='JOHN WAYNE ONLY' 2='EL TORO ONLY' 3='BOTH' 4='OTHER' 
                  8='DK' 9='REFUSE' ;
  VALUE q24fffff  1='EXCELLENT' 2='GOOD' 3='FAIR' 4='POOR' 8='DK' 9='REFUSE' ;
  VALUE q25fffff  1='FOR TAX HIKE' 2='AGAINST TAX HIKE' 8='DK' 9='REFUSE' ;
  VALUE q26fffff  1='FAVOR' 2='OPPOSE' 8='DK' 9='REFUSE' ;
  VALUE q27fffff  1='FAVOR' 2='OPPOSE' 8='DK' 9='REFUSE' ;
  VALUE q28fffff  1='SATISFACTORY' 2='MORE LANES ONLY' 3='NEW FREEWAYS' 
                  9='DK, REFUSE' ;
  VALUE q29fffff  1='VERY SATISFIED' 2='SOMEWHAT SATISFIED' 3='NOT SATISFIED' 
                  8='DK' 9='REFUSE' ;
  VALUE q30fffff  1='FULL-TIME' 2='PART-TIME' 3='NOT EMPLOYED' 9='REFUSE' ;
  VALUE q31fffff  1='NO PROBLEM' 2='SOME PROBLEM' 3='GREAT PROBLEM' 9='NA' ;
  VALUE q32fffff  1='MAJOR' 2='MINOR' 3='NONE' 8='DK' 9='REFUSE' ;
  VALUE q33fffff  1='MAJOR' 2='MINOR' 3='NONE' 8='DK' 9='REFUSE' ;
  VALUE q34fffff  1='MAJOR' 2='MINOR' 3='NONE' 8='DK' 9='REFUSE' ;
  VALUE q35fffff  1='MAJOR' 2='MINOR' 3='NONE' 8='DK' 9='REFUSE' ;
  VALUE q36fffff  1='MAJOR' 2='MINOR' 3='NONE' 8='DK' 9='REFUSE' ;
  VALUE q37fffff  1='MAJOR' 2='MINOR' 3='NONE' 8='DK' 9='REFUSE' ;
  VALUE q38fffff  1='YES, GIVE' 2='YES, DONT GIVE' 3='YES, DONT KNOW' 4='NO' 
                  8='DK' 9='REFUSE' ;
  VALUE q39fffff  1='YES, DEDUCT' 2='YES, NO DEDUCT' 3='YES, DONT KNOW' 
                  4='NO' 8='DK' 9='REFUSE' ;
  VALUE q40fffff  1='YES, BEQUEST' 2='YES, NO BEQUEST' 3='YES, DONT KNOW' 
                  4='NO' 8='DK' 9='REFUSE' ;
  VALUE q41fffff  1='YES' 2='NO' 8='DK' 9='REFUSE' ;
  VALUE q42fffff  1='NOTHING' 2='$1-$100' 3='$101-$250' 4='$251-$500' 
                  5='$501-$999' 6='$1000+' 8='DK' 9='DK, REFUSE' ;
  VALUE q43fffff  1='YES, 1' 2='YES, 2+' 3='NO' 8='DK' 9='REFUSE' ;
  VALUE q44fffff  1='DEMOCRAT' 2='REPUBLICAN' 3='INDEP/OTHER' 4='NOT REGD' 
                  9='REFUSE' ;
  VALUE q45fffff  1='VERY LIBERAL' 2='SOMEWHAT LIBERAL' 3='MIDDLE OF ROAD' 
                  4='SOMEWHAT CONSERV' 5='VERY CONSERV' 9='REFUSE' ;
  VALUE q46fffff  1='GREAT DEAL' 2='FAIR AMT' 3='A LITTLE' 4='NONE' 8='DK' 
                  9='REFUSE' ;
  VALUE q47fffff  1='MOST OF TIME' 2='SOME OF TIME' 3='NOW AND THEN' 
                  4='HARDLY AT ALL' 8='DK' 9='REFUSE' ;
  VALUE q48fffff  1='ALWAYS' 2='NEARLY ALWAYS' 3='PART OF TIME' 4='SELDOM' 
                  5='NEVER' 6='OTHER' 8='DK' 9='REFUSE' ;
  VALUE q49fffff  1='WASTEFUL' 2='DOES BETTER JOB' 8='DK' 9='REFUSE' ;
  VALUE q50fffff  1='NECESSARY' 2='MORE HARM' 8='DK' 9='REFUSE' ;
  VALUE q51fffff  1='HAVE IT EASY' 2='HARD LIVES' 8='DK' 9='REFUSE' ;
  VALUE q52fffff  1='SHD DO MORE' 2='CANT AFFORD MORE' 8='DK' 9='REFUSE' ;
  VALUE q53fffff  1='TOO MUCH PROFIT' 2='FAIR AMT' 8='DK' 9='REFUSE' ;
  VALUE q54fffff  1='CARE' 2='DONT CARE' 8='DK' 9='REFUSE' ;
  VALUE q55fffff  1='COST JOBS' 2='WORTH COST' 8='DK' 9='REFUSE' ;
  VALUE q56fffff  1='ACCEPTED' 2='DISCOURAGED' 8='DK' 9='REFUSE' ;
  VALUE q57fffff  1='BANNED' 2='CARRY ANY BOOK' 8='DK' 9='REFUSE' ;
  VALUE q58fffff  1='STRENGTHEN COUNTRY' 2='BURDEN COUNTRY' 8='DK' 9='REFUSE' ;
  VALUE q59fffff  1='REDUCE TAXES' 2='SPEND MORE' 8='DK' 9='REFUSE' ;
  VALUE q60fffff  1='TOO HIGH' 2='ABOUT RIGHT' 3='TOO LOW' 8='DK' 9='REFUSE' ;
  VALUE q61fffff  1='18-34' 2='35-54' 3='55+' 9='REFUSE' ;
  VALUE q62fffff  1='< H.S.' 2='H.S. GRAD' 3='SOME COLLEGE' 4='COLLEGE GRAD' 
                  5='POST GRAD' 9='REFUSE' ;
  VALUE q63fffff  1='YES, PUBLIC SCHOOL' 2='YES, NO PUB SCH' 3='NO CHILDREN' 
                  8='DK' 9='REFUSE' ;
  VALUE q65fffff  1='UNDER $36,000' 2='$36,000-$50,000' 3='$50,001-$79,999' 
                  4='$80,000+' 9='DK, REFUSE' ;
  VALUE q66fffff  1='ASIAN' 2='BLACK' 3='HISPANIC' 4='CAUCASIAN' 5='OTHER' 
                  9='REFUSE' ;
  VALUE sex       1='MALE' 2='FEMALE' ;
  VALUE lang      1='ENGLISH' 2='SPANISH' ;
  VALUE city      1='NORTH' 2='WEST' 3='CENTRAL' 4='SOUTH' 5='OUTSIDE OC' 
                  9='NO ANS' ;
  VALUE yearffff  1997='YEAR OF SURVEY' ;
RUN;

DATA IN (LABEL="ORANGE COUNTY ANNUAL SURVEY 1997");
  INFILE INDATA LRECL=78;
  INPUT
    #1  CASEID 1-4              Q1 5                    Q2 6                    
        Q3 7                    Q4 8                    Q5 9                    
        Q6 10                   Q7 11                   Q8 12                   
        Q9 13                   Q10 14                  Q11 15                  
        Q12 16                  Q13 17                  Q14 18-19               
        Q15 20                  Q16 21                  Q17 22                  
        Q18 23                  Q19 24                  Q20 25                  
        Q21 26                  Q22 27                  Q23 28                  
        Q24 29                  Q25 30                  Q26 31                  
        Q27 32                  Q28 33                  Q29 34                  
        Q30 35                  Q31 36                  Q32 37                  
        Q33 38                  Q34 39                  Q35 40                  
        Q36 41                  Q37 42                  Q38 43                  
        Q39 44                  Q40 45                  Q41 46                  
        Q42 47                  Q43 48                  Q44 49                  
        Q45 50                  Q46 51                  Q47 52                  
        Q48 53                  Q49 54                  Q50 55                  
        Q51 56                  Q52 57                  Q53 58                  
        Q54 59                  Q55 60                  Q56 61                  
        Q57 62                  Q58 63                  Q59 64                  
        Q60 65                  Q61 66                  Q62 67                  
        Q63 68                  Q65 69                  Q66 70                  
        SEX 71                  LANG 72                 CITY 73-74              
        YEAR 75-78              ;

  LABEL
   CASEID  = 'RESPONDENT ID'
   Q1      = 'RESIDENCE TYPE'
   Q2      = 'YEARS OF RESIDENCE (range)'
   Q3      = 'OWN PRESENT RESIDENCE'
   Q4      = 'MONTHLY RENT (range)'
   Q5      = 'MONTHLY MORTGAGE (range)'
   Q6      = 'FINANCIALLY BETTER OFF THAN LAST YEAR?'
   Q7      = 'BETTER OFF NEXT YEAR?'
   Q8      = 'U.S. BUSINESS CONDS NEXT 12 MONTHS'
   Q9      = 'U.S. BUSINESS CONDITIONS NEXT 5 YEARS'
   Q10     = 'MAJOR HOUSEHOLD PURCHASES'
   Q11     = 'ORANGE COUNTY ECONOMY'
   Q12     = 'INVESTING IN HOMES IN ORANGE COUNTY'
   Q13     = 'QUALITY OF LIFE?'
   Q14     = 'MOST SERIOUS PUBLIC POLICY ISSUE'
   Q15     = 'MOST SERIOUS HEALTH AND SOCIAL ISSUE'
   Q16     = 'ORANGE COUNTY A BETTER PLACE TO LIVE?'
   Q17     = 'COUNTY GOVERNMENT PERFORMANCE'
   Q18     = 'COUNTY''S ATTENTION PAID TO PEOPLE'
   Q19     = 'COUNTY WASTING TAXES?'
   Q20     = 'COUNTY & EL TORO'
   Q21     = 'FAVOR EL TORO AIRPORT?'
   Q22     = 'PREFERRED EL TORO PROPOSAL'
   Q23     = 'ORANGE COUNTY AIR TRAVEL NEEDS'
   Q24     = 'SATISFIED WITH LOCAL PUBLIC SCHOOLS?'
   Q25     = 'RAISE TAXES FOR LOCAL SCHOOLS'
   Q26     = 'RAISE SCHOOL TAXES WITH SIMPLE MAJORITY'
   Q27     = 'PASS SCHOOL BONDS WITH SIMPLE MAJORITY'
   Q28     = 'SATISFIED WITH LOCAL FREEWAYS?'
   Q29     = 'SATISFIED WITH USE OF MEASURE M FUNDS'
   Q30     = 'WORK STATUS'
   Q31     = 'TRAFFIC CONGESTION DURING COMMUTE'
   Q32     = 'MOTIVATION: HELPING INDIVIDUALS MEET NEEDS'
   Q33     = 'MOTIVATION: FRIEND ASKED TO CONTRIBUTE'
   Q34     = 'MOTIVATION: GIVING BACK TO SOCIETY'
   Q35     = 'MOTIVATION: KEEPING TAXES DOWN'
   Q36     = 'MOTIVATION: ENCOURAGED BY EMPLOYER'
   Q37     = 'MOTIVATION: HELP TH0SE WHO HAVE LESS'
   Q38     = 'PAYROLL DEDUCTIONS AT WORK'
   Q39     = 'ITEMIZED DEDUCTIONS ON 96 TAX RETURN'
   Q40     = 'HAVE A WILL'
   Q41     = 'BEEN ASKED TO GIVE IN PAST YEAR'
   Q42     = 'MONEY GIVEN TO CHARITIES LAST YEAR'
   Q43     = 'VOLUNTEER WORK IN PAST 12 MONTHS?'
   Q44     = 'PARTY REGISTRATION'
   Q45     = 'CONSIDER YOURSELF POLITICALLY'
   Q46     = 'HOW INTERESTED IN POLITICS'
   Q47     = 'FOLLOW GOVERNMENT AND PUBLIC AFFAIRS'
   Q48     = 'VOTE FREQUENCY'
   Q49     = 'GOVERNMENT EFFICIENCY'
   Q50     = 'GOVERNMENT REGULATION ON BUSINESS'
   Q51     = 'LIVELIHOOD OF THE POOR'
   Q52     = 'GOVERNMENT HELPING NEEDY'
   Q53     = 'BUSINESS CORPORATIONS AND PROFIT'
   Q54     = 'ELECTED OFFICIALS RECEPTIVE?'
   Q55     = 'ENVIRONMENTAL LAWS'
   Q56     = 'HOMOSEXUALITY'
   Q57     = 'BOOKS IN PUBLIC SCHOOL LIBRARIES'
   Q58     = 'IMMIGRANTS'
   Q59     = 'TAXES VS SOCIAL PROGRAMS'
   Q60     = 'FEDERAL TAXES'
   Q61     = 'AGE (range)'
   Q62     = 'LAST GRADE OF SCHOOL COMPLETED'
   Q63     = 'HAVE KIDS IN PUBLIC SCHOOLS?'
   Q65     = 'ANNUAL HOUSEHOLD INCOME (range)'
   Q66     = 'RACE AND ETHNICITY'
   SEX     = 'GENDER (sex)'
   LANG    = 'LANGUAGE OF INTERVIEW'
   CITY    = 'CITY'
   YEAR    = 'YEAR OF SURVEY'
        ;

  FORMAT Q1 q1ffffff. Q2 q2ffffff. Q3 q3ffffff. 
         Q4 q4ffffff. Q5 q5ffffff. Q6 q6ffffff. 
         Q7 q7ffffff. Q8 q8ffffff. Q9 q9ffffff. 
         Q10 q10fffff. Q11 q11fffff. Q12 q12fffff. 
         Q13 q13fffff. Q14 q14fffff. Q15 q15fffff. 
         Q16 q16fffff. Q17 q17fffff. Q18 q18fffff. 
         Q19 q19fffff. Q20 q20fffff. Q21 q21fffff. 
         Q22 q22fffff. Q23 q23fffff. Q24 q24fffff. 
         Q25 q25fffff. Q26 q26fffff. Q27 q27fffff. 
         Q28 q28fffff. Q29 q29fffff. Q30 q30fffff. 
         Q31 q31fffff. Q32 q32fffff. Q33 q33fffff. 
         Q34 q34fffff. Q35 q35fffff. Q36 q36fffff. 
         Q37 q37fffff. Q38 q38fffff. Q39 q39fffff. 
         Q40 q40fffff. Q41 q41fffff. Q42 q42fffff. 
         Q43 q43fffff. Q44 q44fffff. Q45 q45fffff. 
         Q46 q46fffff. Q47 q47fffff. Q48 q48fffff. 
         Q49 q49fffff. Q50 q50fffff. Q51 q51fffff. 
         Q52 q52fffff. Q53 q53fffff. Q54 q54fffff. 
         Q55 q55fffff. Q56 q56fffff. Q57 q57fffff. 
         Q58 q58fffff. Q59 q59fffff. Q60 q60fffff. 
         Q61 q61fffff. Q62 q62fffff. Q63 q63fffff. 
         Q65 q65fffff. Q66 q66fffff. SEX sex. 
         LANG lang. CITY city. YEAR yearffff. 
          ;

/* md, min and max specifications were translated  */
/* into the following "IF" statements:           */

IF (Q1 = 9) THEN Q1 = .;
IF (Q2 = 9) THEN Q2 = .;
IF (Q3 = 9) THEN Q3 = .;
IF (Q4 = 9) THEN Q4 = .;
IF (Q5 = 9) THEN Q5 = .;
IF (Q6 = 9) THEN Q6 = .;
IF (Q7 = 9) THEN Q7 = .;
IF (Q8 = 9) THEN Q8 = .;
IF (Q9 = 9) THEN Q9 = .;
IF (Q10 = 9) THEN Q10 = .;
IF (Q11 = 9) THEN Q11 = .;
IF (Q12 = 9) THEN Q12 = .;
IF (Q13 = 9) THEN Q13 = .;
IF (Q14 = 99) THEN Q14 = .;
IF (Q15 = 9) THEN Q15 = .;
IF (Q16 = 9) THEN Q16 = .;
IF (Q17 = 9) THEN Q17 = .;
IF (Q18 = 9) THEN Q18 = .;
IF (Q19 = 9) THEN Q19 = .;
IF (Q20 = 9) THEN Q20 = .;
IF (Q21 = 9) THEN Q21 = .;
IF (Q22 = 9) THEN Q22 = .;
IF (Q23 = 9) THEN Q23 = .;
IF (Q24 = 9) THEN Q24 = .;
IF (Q25 = 9) THEN Q25 = .;
IF (Q26 = 9) THEN Q26 = .;
IF (Q27 = 9) THEN Q27 = .;
IF (Q28 = 9) THEN Q28 = .;
IF (Q29 = 9) THEN Q29 = .;
IF (Q30 = 9) THEN Q30 = .;
IF (Q31 = 9) THEN Q31 = .;
IF (Q32 = 9) THEN Q32 = .;
IF (Q33 = 9) THEN Q33 = .;
IF (Q34 = 9) THEN Q34 = .;
IF (Q35 = 9) THEN Q35 = .;
IF (Q36 = 9) THEN Q36 = .;
IF (Q37 = 9) THEN Q37 = .;
IF (Q38 = 9) THEN Q38 = .;
IF (Q39 = 9) THEN Q39 = .;
IF (Q40 = 9) THEN Q40 = .;
IF (Q41 = 9) THEN Q41 = .;
IF (Q42 = 9) THEN Q42 = .;
IF (Q43 = 9) THEN Q43 = .;
IF (Q44 = 9) THEN Q44 = .;
IF (Q45 = 9) THEN Q45 = .;
IF (Q46 = 9) THEN Q46 = .;
IF (Q47 = 9) THEN Q47 = .;
IF (Q48 = 9) THEN Q48 = .;
IF (Q49 = 9) THEN Q49 = .;
IF (Q50 = 9) THEN Q50 = .;
IF (Q51 = 9) THEN Q51 = .;
IF (Q52 = 9) THEN Q52 = .;
IF (Q53 = 9) THEN Q53 = .;
IF (Q54 = 9) THEN Q54 = .;
IF (Q55 = 9) THEN Q55 = .;
IF (Q56 = 9) THEN Q56 = .;
IF (Q57 = 9) THEN Q57 = .;
IF (Q58 = 9) THEN Q58 = .;
IF (Q59 = 9) THEN Q59 = .;
IF (Q60 = 9) THEN Q60 = .;
IF (Q61 = 9) THEN Q61 = .;
IF (Q62 = 9) THEN Q62 = .;
IF (Q63 = 9) THEN Q63 = .;
IF (Q65 = 9) THEN Q65 = .;
IF (Q66 = 9) THEN Q66 = .;

PROC DATASETS;
  CONTENTS DATA=IN POSITION;
  TITLE 'CONTENTS OF ALL VARIABLES';
RUN;
